<%'Dynamic Link set Product_InformationRecordSet = CreateObject("ADODB.RecordSet") Product_InformationRecordSet.Open "select * from Products where Category = 'Saw Blades'", ConnectString("LooseScrews") set Product_Information = WrapRecordSet(Product_InformationRecordSet, "ProductID") %>

Creating a Dynamic Table
1. Layout a template table using the same formatting that the final table should have.
2. Bind the elements in the first row you want to replace to appropriate pieces of dynamic content.
3. Select the table.
4. Check the Replace Rows option in the Binding Details tab of the Dynamic Link palette.
<% Product_Information.MoveFirst %> <% while not Product_Information.EOF %> <% Product_Information.MoveNext %> <% wend %>
Product Type Price
<%=Product_Information.Value("Type")%> $<%=Product_Information.Value("Price")%>
<% if 0 then %> <% end if %>